﻿CREATE VIEW [dbo].[UserWhsTowerImages] AS
SELECT il.[InstanceId],ti.[TowerJpeg]
  FROM [UserSystemInfosLatest] il
  RIGHT JOIN [WhsTowerImages] ti
  ON (il.[InstanceId]=ti.[InstanceId])
  OR (il.[SystemManufacturer]=ti.[SystemManufacturer] AND il.[SystemModel]=ti.[SystemModel])